
TRUNCATE table [TestCDOBug_Parent];
TRUNCATE table [TestCDOBug_Child];
TRUNCATE table [TestCDOBug_Grandson];

INSERT INTO [dbo].[TestCDOBug_Parent]([ID], [Code], [Name], [Creator], [CreatorName], [CreateTime], [LastModifier], [LastModifierName], [LastModifyTime]) VALUES ('Parent-1', 'Parent-1', 'Parent-1', '873A4ADD-A93C-4ECB-A2F6-E812A2F48CA2', 'user1', '2022-11-01 11:51:30.587', '873A4ADD-A93C-4ECB-A2F6-E812A2F48CA2', 'user1', '2022-11-01 16:08:56.333');
INSERT INTO [dbo].[TestCDOBug_Parent]([ID], [Code], [Name], [Creator], [CreatorName], [CreateTime], [LastModifier], [LastModifierName], [LastModifyTime]) VALUES ('Parent-2', 'Parent-2', 'Parent-2', '873A4ADD-A93C-4ECB-A2F6-E812A2F48CA2', 'user1', '2022-11-01 11:51:30.587', '873A4ADD-A93C-4ECB-A2F6-E812A2F48CA2', 'user1', '2022-11-01 16:08:56.333');
INSERT INTO [dbo].[TestCDOBug_Parent]([ID], [Code], [Name], [Creator], [CreatorName], [CreateTime], [LastModifier], [LastModifierName], [LastModifyTime]) VALUES ('Parent-3', 'Parent-3', 'Parent-3', '873A4ADD-A93C-4ECB-A2F6-E812A2F48CA2', 'user1', '2022-11-01 11:51:30.587', '873A4ADD-A93C-4ECB-A2F6-E812A2F48CA2', 'user1', '2022-11-01 16:08:56.333');
INSERT INTO [dbo].[TestCDOBug_Parent]([ID], [Code], [Name], [Creator], [CreatorName], [CreateTime], [LastModifier], [LastModifierName], [LastModifyTime]) VALUES ('Parent-4', 'Parent-4', 'Parent-4', '873A4ADD-A93C-4ECB-A2F6-E812A2F48CA2', 'user1', '2022-11-01 11:51:30.587', '873A4ADD-A93C-4ECB-A2F6-E812A2F48CA2', 'user1', '2022-11-01 16:08:56.333');
INSERT INTO [dbo].[TestCDOBug_Child]([ID], [Code], [Name], [Creator], [CreatorName], [CreateTime], [LastModifier], [LastModifierName], [LastModifyTime], [MyParent]) VALUES ('Child-1', 'Child-1', 'Child-1', NULL, NULL, '2022-11-01 15:22:52.000', '873A4ADD-A93C-4ECB-A2F6-E812A2F48CA2', 'user1', '2022-11-01 15:51:02.137', 'Parent-1');
INSERT INTO [dbo].[TestCDOBug_Child]([ID], [Code], [Name], [Creator], [CreatorName], [CreateTime], [LastModifier], [LastModifierName], [LastModifyTime], [MyParent]) VALUES ('Child-2', 'Child-2', 'Child-2', NULL, NULL, '2022-11-01 15:23:23.000', '873A4ADD-A93C-4ECB-A2F6-E812A2F48CA2', 'user1', '2022-11-01 15:25:00.853', 'Parent-1');
INSERT INTO [dbo].[TestCDOBug_Child]([ID], [Code], [Name], [Creator], [CreatorName], [CreateTime], [LastModifier], [LastModifierName], [LastModifyTime], [MyParent]) VALUES ('Child-3', 'Child-3', 'child-368', '873A4ADD-A93C-4ECB-A2F6-E812A2F48CA2', 'user1', '2022-11-01 16:04:11.397', '873A4ADD-A93C-4ECB-A2F6-E812A2F48CA2', 'user1', '2022-11-01 16:08:56.333', 'Parent-1');
INSERT INTO [dbo].[TestCDOBug_Grandson]([ID], [Code], [Name], [Creator], [CreatorName], [CreateTime], [LastModifier], [LastModifierName], [LastModifyTime], [MyParent]) VALUES ('grandson-1', 'grandson-1', 'grandson-1', 'grandson-1', 'grandson-1', '2022-11-01 15:47:38.000', '873A4ADD-A93C-4ECB-A2F6-E812A2F48CA2', 'user1', '2022-11-01 15:49:47.020', 'Child-1');
INSERT INTO [dbo].[TestCDOBug_Grandson]([ID], [Code], [Name], [Creator], [CreatorName], [CreateTime], [LastModifier], [LastModifierName], [LastModifyTime], [MyParent]) VALUES ('grandson-2', 'grandson-2', 'grandson-2', '873A4ADD-A93C-4ECB-A2F6-E812A2F48CA2', 'user1', '2022-11-01 15:49:47.020', '873A4ADD-A93C-4ECB-A2F6-E812A2F48CA2', 'user1', '2022-11-01 15:49:47.027', 'Child-1');
INSERT INTO [dbo].[TestCDOBug_Grandson]([ID], [Code], [Name], [Creator], [CreatorName], [CreateTime], [LastModifier], [LastModifierName], [LastModifyTime], [MyParent]) VALUES ('grandson-3', 'grandson-3', 'grandson-3', '2', '2', '2022-11-01 15:47:52.000', '873A4ADD-A93C-4ECB-A2F6-E812A2F48CA2', 'user1', '2022-11-01 15:49:47.020', 'Child-1');
INSERT INTO [dbo].[TestCDOBug_Grandson]([ID], [Code], [Name], [Creator], [CreatorName], [CreateTime], [LastModifier], [LastModifierName], [LastModifyTime], [MyParent]) VALUES ('grandson-4', 'grandson-4', 'grandson-4', 'grandson-4', 'grandson-4', '2022-11-01 16:06:33.000', '873A4ADD-A93C-4ECB-A2F6-E812A2F48CA2', 'user1', '2022-11-01 16:07:20.870', 'Child-2');
INSERT INTO [dbo].[TestCDOBug_Grandson]([ID], [Code], [Name], [Creator], [CreatorName], [CreateTime], [LastModifier], [LastModifierName], [LastModifyTime], [MyParent]) VALUES ('grandson-5', 'grandson-5', 'grandson-5', 'grandson-5', 'grandson-5', '2022-11-01 16:07:55.000', 'grandson-368-2', 'grandson-368-2', '2022-11-01 16:07:58.000', 'Child-2');
